﻿CREATE PROCEDURE [dbo].[proc_ManagementArea_IsDelete]
	(
		@Id INT
	)
AS
	begin TRAN
     SET SELECT COUNT(*) AS bms ,(SELECT ma.CompanyName FROM ManagementArea ma WHERE ma.Id=@Id) AS cm FROM Company c WHERE c.Mid=@Id 
	commit tran
	RETURN